﻿CREATE PROCEDURE [dbo].[aspnet_Personalization_GetApplicationId]
@ApplicationName NVARCHAR (256), @ApplicationId UNIQUEIDENTIFIER OUTPUT
AS
BEGIN
    SELECT @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
END